Re: [SQL] dilemma
От
Herouth Maoz
Тема
Re: [SQL] dilemma
Дата
Msg-id
l03110700b24a22c17e45@[194.90.105.243]
Ответ на
dilemma (Eric McKeown)
Список
Дерево обсуждения
dilemma Eric McKeown <ericm@palaver.net>
Re: [SQL] dilemma Herouth Maoz <herouth@oumail.openu.ac.il>
Using the IN predicate in an UPDATE... Thomas Good <tomg@admin.nrnet.org>
Re: [SQL] Using the IN predicate in an UPDATE... Leslie Mikesell <les@Mcs.Net>
Re: [SQL] Using the IN predicate in an UPDATE... Thomas Good <tomg@admin.nrnet.org>
Re: [SQL] Using the IN predicate in an UPDATE... Herouth Maoz <herouth@oumail.openu.ac.il>
Re: Using the IN predicate in an UPDATE... Herouth Maoz <herouth@oumail.openu.ac.il>
Re: [SQL] Re: Using the IN predicate in an UPDATE... "Gene Selkov Jr." <selkovjr@mcs.anl.gov>
At 4:24 +0200 on 14/10/98, Eric McKeown wrote: > Is there a better way to design this? I thought about making the option > ids for each vehicle a comma-delimited text field, but maybe the search > would be even slower if I did that. Since I'm not a SQL expert, I don't > know, but I'm asking all the experts out there--how should I set this > thing up?? Your solution is the best, most classic solution. You just need to index the relational table properly (Put an index on each of the fields). Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma
В списке pgsql-sql по дате отправления
